This assignment is for ETC5521 Assignment 1 by Team brolga comprising of Hanchen Wang and Jiaying Zhang.
It has been 45 years since the first landline telephone was invented in 1876. The telephone has changed a lot from how it works to how it looks. Today, mobile technology has spread rapidly around the globe and it is estimated that more than 5 billion people have mobile devices, and over half of these connections are smartphones.
“Digital connectivity plays a critical role in bettering lives, as it opens the door to unprecedented knowledge, employment and financial opportunities for billions of people worldwide,” said ITU Secretary-General Houlin Zhao. Because the telephone plays a crucial role in our life, we think it is valuable to analyze it.
This analysis is based on information about mobile and landline phones collected by the ITU (2021) -International Telecommunication Union and would like to analyze the phone subscription trend, percentage and other factors.
Specially:
1.What is the trend in subscription of phone and landline worldwide between 1990 and 2017?
2.What was the growth rate of the subscription of mobile phones in each country from 2013 to 2017 and what was the proportion of the subscription of phone and landline from 2000?
3.What is the regression relationship between phone subscriptions and other variables?
The datasets are downloaded from the Github repository of Tidy Tuesday. Tidy Tuesday (2021) is a weekly data project aimed at the R ecosystem and this report will use datasets adopted by it on November 10, 2020.
There are two datasets provided in the repository and all of them came from an article-“Technology Adoption” which written by Ritchie and Roser (2017) on 2017 OurWorldInData.org.
Tidy Tuesday (2021) only made a few changes to the original data and already can get relatively clean data that can be used for analysis, mainly by matching the time of several original data, screening the data from 1990 to 2017, and adding the corresponding continent of each country.
landline.csv)The dataset about Fixed(landline) telephone subscriptions vs GDP per capita also originated from “Technology Adoption.” It published by (Worldbank 2021 – World Development Indicators)(http://data.worldbank.org/data-catalog/world-development-indicators) and collected by (ITU 2021 - International Telecommunication Union)(https://www.itu.int/en/ITU-D/Statistics/Pages/publications/wtid.aspx). The dataset cover the data about fixed telephone subscriptions and GPD per capita in each country during 1960 and 2017.
Fixed telephone subscriptions refers to the sum of active number of analogue fixed telephone lines, voice-over-IP (VoIP) subscriptions, fixed wireless local loop (WLL) subscriptions, ISDN voice-channel equivalents and fixed public payphones.
landline.csvThis dataset has 6974 number of observations and 7 number of variables. The name, type and description of each variable in landline.csv can be found in the data dictionary below.
| variable | class | description |
|---|---|---|
| entity | character | Country |
| code | character | Country code |
| year | double | Year |
| total_pop | double | Gapminder total population |
| gdp_per_cap | double | GDP per capita, PPP (constant 2011 international $) |
| landline_subs | double | Fixed telephone subscriptions (per 100 people) |
| continent | character | Continent |
Data on fixed telephone lines are derived using administrative data that countries (usually the regulatory telecommunication authority or the Ministry in charge of telecommunications) regularly, and at least annually, collect from telecommunications operators.
Data for this indicator are readily available for approximately 90 percent of countries, either through ITU’s World Telecommunication Indicators questionnaires or from official information available on the Ministry or Regulator’s website. For the rest, information can be aggregated through operators’ data (mainly through annual reports) and complemented by market research reports.
Figure 2.1: Visualise the missing value in landline data
gdp_per_cap and landline_subs, which may have come influence on the results of statistical analysis.mobile.csv)The dataset about Mobilephone subscriptions vs GDP per capita originated from an article-“Technology Adoption.” This dataset was published by (Worldbank 2021 – World Development Indicators)(http://data.worldbank.org/data-catalog/world-development-indicators) and collected by (ITU 2021 - International Telecommunication Union)(https://www.itu.int/en/ITU-D/Statistics/Pages/publications/wtid.aspx). The dataset cover the data about mobilephone subscriptions and GPD per capita in each country from 1960 to 2017.
mobile.csvThis dataset has 6277 number of observations and 7 number of variables. The name, type and description of each variable in mobile.csv can be found in the data dictionary below.
| variable | class | description |
|---|---|---|
| entity | character | Country |
| code | character | Country code |
| year | double | Year |
| total_pop | double | Gapminder total population |
| gdp_per_cap | double | GDP per capita, PPP (constant 2011 international $) |
| mobile_subs | double | Fixed mobile subscriptions (per 100 people) |
| continent | character | Continent |
Mobile cellular telephone subscriptions are subscriptions to a public mobile telephone service that provide access to the PSTN using cellular technology. The indicator includes (and is split into) the number of postpaid subscriptions, and the number of active prepaid accounts (i.e. that have been used during the last three months). The indicator applies to all mobile cellular subscriptions that offer voice communications. It excludes subscriptions via data cards or USB modems, subscriptions to public mobile data services, private trunked mobile radio, telepoint, radio paging and telemetry services.
Data on mobile cellular subscribers are derived using administrative data that countries (usually the regulatory telecommunication authority or the Ministry in charge of telecommunications) regularly, and at least annually, collect from telecommunications operators.
Data for this indicator are readily available for approximately 90 percent of countries, either through ITU’s World Telecommunication Indicators questionnaires or from official information available on the Ministry or Regulator’s website. For the rest, information can be aggregated through operators’ data (mainly through annual reports) and complemented by market research reports.
Figure 2.2: Visualise the missing value in mobile data
gdp_per_cap , total_popand mocile_subs, which may have some influence on the results of statistical analysis.Figure 3.1: The trend of mobile phone and landline subscription by continent from 1990 to 2017
Figure 3.1 shows the basic trends of subscriptions of mobile phone and landline subscriptions from 1990 to 2017 by 5 continents, I combined the two datasets and use some functions like pivot_longer() to adjust the variables as well as plotted the line graph by ggplotly which turns out a better interactive data visualization, but Among them, I grouped the data according to continents rather than countries, because I want to present a clear and intuitive trend figure so that the readers can roughly understand the basic facts reflected by the two datasets. More complex issues between countries even involve GDP per capita and the explanation will be described in the following questions.
From the combined figure, we can find the similarities and differences of trends easily, that Europe has the largest share of subscriptions of both devices over the 27 years, followed by the Americas, Asia and Oceania, and Africa has the fewest subscriptions compared to other continents. As is all known, the development of communication equipment cannot be separated from the level of technological and economic development of a country or region. Europe, as the main market of landline and mobile phones in the second half of the 20th century, naturally occupied a high market share and subscription volume. Although the earliest landline machine was invented in America in Canada, The economic conditions and social level of the countries except for the USA in America determine that the subscriptions are difficult to go beyond Europe, and Oceania is in the same way. However, in Asia and Africa, which are mainly developing countries, such conditions cause the subscription volume of both devices can only lag.
As for the difference, Although mobile phone subscriptions in the five continents were virtually zero in 1990, they exploded exponentially over the next decade. In contrast, landline subscriptions remained at this high level relatively in 1990 in all regions except Africa, but the growth rate was significantly lower, and there was even a decline in Europe. Meanwhile, Africa has remained roughly at the bottom. Overall, landline subscriptions in all regions have remained slow or stagnant for 17 years. the interesting findings can reflect that mobile communication equipment is gradually replacing the traditional landline communication equipment. And such an inevitable trend also reflects the rapid development of human communication technology in the past 20 years.
Figure 3.2: Growth rate of the mobile subscription in each country during 2013 and 2017
(Put mouse on each country you can see the detail about country names and the mobile phone subscription 3 years growth rate of them.)
From the figure 3.2 we can see the increase in mobile phone subscriptions in recent years. In the three years from 2015 to 2017, the number of mobile phone subscriptions was not very large on average, staying at around 0.
There are even countries like France, Russia and Mexico that have a negative growth rate. In three years the subscription of mobile phones in Libreria, decreased by 44%, which is extremely fast. However, it’s worth noting that the number of mobile subscriptions in Somania and Burma grew by 73% over the same period.
Instead of seeing a rise in the number of mobile phones in developed countries, we see a partial decline. Perhaps as mentioned by Laura Silver (2021), the developed economies have already completed the popularization of mobile phones in the early stage. Now, compared with the increase in the number, the main trend is that smartphones replace ordinary mobile phones.
{r animasub, fig.cap= "Compare proportion of the subscription of phone and landline from 2000 to 2017"} # proanimation <- # q2_datapro%>% # ggplot( aes(x = landline_subs, # y = mobile_subs, # size = total_pop, # color = continent)) + # geom_point() + # theme_bw() + # labs(title = 'Year: {round(frame_time)}', # x = 'landline subscription(per 100 people)', # y = 'mobile subscription(per 100 people)') + # transition_time(year)+ # ease_aes('linear') # # animate(plot = proanimation, # render = gifski_renderer(), # duration = 18, # fps = 20) # # anim_save("proanimate.gif") #As we can see from the animation ??, the main trend since 2000 is that the number of fixed-line phones has been decreasing while the number of mobile phones has been increasing.
European countries have more fixed-line phones, and more people still use them recently. Most African countries, by contrast, rarely use landlines.
This may be because people in European countries used to have landlines, so even as mobile phones became more popular, they still had a large proportion of people using them. However, African countries rarely used landline telephone from the beginning, so with the advent of mobile phones, they did not have the process of a landline to the mobile phone, and chose mobile phone directly.
Figure 4.1: Proportion of the subscription of phone and landline in 2000 and 2017
Picture 4.1 showed us more detailed information, compares the 2000 and 2017 of fixed telephone and mobile phone subscriptions per 100 people. We can see that in most countries the number of fixed phone fell sharply, only less than 50, on the contrary, there are quite a few people have more mobile phone at the same time. On average, most people own a mobile phone, and 100 people have an average of less than 25 landline phones.
This trend did not happen recently, in 2006 “Cell Phone Users Are Giving up Their Landline Service” (2006) already said that one in five consumers who currently use wireless telephone service plan to drop their landline service, according to In-Stat. Besides, it’s worth noting that Monaco has a far higher percentage of fixed-line phones than any other country, while Hong Kong has nearly 2.5 mobile phones per person.
The spread of mobile phone devices can be shown as the number of people who use mobile phones. Since the modern lifestyle people are more and more connected to the usage of mobile phone, which has a significant difference from last 10 or 20 years.
According to the first question, it found that the penetration rate of mobile phones has been increasing year by year, so it is meaningful to look at what factors are related to mobile phone subscriptions and find out any possible relationships associated with it. From the experience, it suggests the mobile phone subscription may have an association with the time factor and GDP per capita. Thus, using these two as the independent variables for the test fitting function may be helpful, and applying this function to all the countries to see if it is suitable to predict for the whole data set.
Figure 4.2: The fitted relationship of mobile phone subscription with year gap from 1990 to 2017
Firstly, set up the fitting linear function: mobile_subs ~ year1990 + gdp_per_cap, which year1990 can be regarded as the difference between each year and 1990. In this case, this year gap becomes a value from 1 to 27 with 1990 as the base year, which can better judge the participation of the “year” variable in the model. Since I wanted to make a fitting model for each city, I had to use the nest() function and map function to fit lm to all countries and map the function to data column of tidy data, and use augment() to plot all the models, which is indeed a complicated process.
As shown in Figure 4.2, it looks very complicated. Yet, it still shows a similar pattern of the mobile phone subscriptions in question 1, which may suggest the fitting relationship between mobile phone subscriptions and the year gap in each country is very similar. Interestingly, Macao and Hong Kong as the Asian regions have a higher fitted value in 2017. According to the data available, it is true that these two regions have had very high subscriptions in recent years, but does this mean that they have a fitting model with a larger slope? Similarly, another Asian country, Myanmar has the lowest fitted value in 2017, so does it has a smaller slope?
Figure 4.3: The fitted relationship of mobile phone subscription with year gap from 1990 to 2017
To check the slope and intercept of the model for each country, I use the augment()to plot all the models. As shown in Figure 4.3, it demonstrates the intercept and year slope of the model of each country.
For example, the tidy model of Australia is as following: \[\widehat{mobile-subs} = -274.173053 - 1.2974~year1990 + 29.3258~gdp-per-cap\]
Here are some interesting findings:
Generally, more than two-thirds of countries have a positive slope, which means most countries tend to have a constant increase in subscriptions.
There is a difference across the continents: Countries in Europe and Oceania tended to start with a more positive slope, which means a positively increasing rate of subscription; countries in Asia tended to start lower but have high rates of improvement; Africa tends to start lower and has a huge range in the rate of change and most countries who have negative growth.
Sure enough, Macao and Hongkong have the higher slope relatively as well as Myanmar had the lower slope.
Seems most countries had a negative intercept, which was supposed to be the two possible reasons, one is that all the countries did have nearly zero mobile phone subscriptions in 1990, second is that the model was affected by another factor: GDP per capita.
Figure 4.4: q3_gdp_lm_fig
Finally, let’s focus on the model for GDP per capita. This time, to avoid the interference of the year on the model graphs, it can be done by using facet_wrap(~year) to separate each graph.
As shown in Figure 4.4, the relationship between GDP per capita and mobile phone subscriptions in this model can be intuitively reflected. It is not difficult to find that the slope of each continent between 1990 and 1997 was almost zero. But after 1997, all of them have a positive slope which shows that GDP per capita and mobile phone subscription volume have a positive correlation.
This may cause by the relationship that a higher GDP per capita will have greater purchasing power. Often people with higher purchasing power can afford high-tech products. In the last century, Europe, as a typical high-income region, naturally had a higher GDP per capita and therefore a higher telephone subscription volume, which in turn had a greater growth rate than other regions.
It maintained a relatively high slope growth rate until 2007, and its slope was overtaken by Asia, and then the growth rate declined slowly until 2017. This also reflects that with the change of the times and the development of global technology, the cost of mobile phone products has become cheaper and more accessible to people. The number of subscriptions is essentially affected by additional mobile phone accounts and call charges. The rise of Asian mobile phone subscriptions, maybe due to the rapid development of the associated infrastructures, manufacture and service of the mobile phone industries. To ensure small profits but quick turnover, many technology companies are willing to produce cheaper mobile phone products with more affordable costs and services to attract more consumers.
Figure 4.5: The fitted relationship of mobile phone subscription with year gap from 1990 to 2017
The 4.4 shows the coefficient of the model for GDP per capita and phone subscription. It shows that most countries in Africa have a higher slope and negative intercept, that is because the economic development of many African countries is relatively slow and unbalanced. In the initial stage, mobile phone subscriptions remain at a very low level, but there are still some countries with a relatively higher GDP per capita such as South Africa that can achieve a higher mobile phone subscription rate than others.
| continent | r.squared | adj.r.squared | AIC | BIC |
|---|---|---|---|---|
| Africa | 0.8316 | 0.8150 | 173.7 | 178.3 |
| Americas | 0.8943 | 0.8838 | 193.5 | 198.1 |
| Asia | 0.8984 | 0.8883 | 181.4 | 186.0 |
| Europe | 0.9488 | 0.9420 | 168.8 | 173.1 |
| Oceania | 0.8302 | 0.8130 | 144.6 | 148.9 |
Lastly, let’s have a look at the compatibility of the prediction model. Table 4.1 uses glance() from the previously fitted model to extract the information. The values of r.squared are large, with a relatively acceptable level of AIC and BIC values which are used to penalize the artificial increase of r.squared values. This may suggest that this prediction model may be reasonable to use for the prediction on mobile phone subscriptions with careful further examinations.
Figure 4.6: The inapplicable situation
Figure 4.7: The inapplicable entities
According to the \(R^2\) values, figure fig 4.6 will show a histogram to illustrate the information. It suggests some countries may not have a positive linear relationship between mobile phone subscriptions and GDP per capita and time factor.
Additionally, constructing scatterplots with a linear fitting on those with low \(R^2\) values countries (i.e. filtering the countries with \(R^2<0.65\)), to check if the relationship is not linear in these countries. From figure fig 4.7, four countries are detected. For the majority of the countries, the prediction model fits acceptably well, yet the cause of incompatibility for these four countries may be due to the incompetence of the data set or inaccurate records on the mobile phone subscriptions 15 years ago or maybe other underlying factors.
In conclusion, from the above analysis, we can see that the number of mobile phones has been growing rapidly since 1990, while the number of fixed phones has also more than that in 1990, but it shows a decline recently.
Overall, European countries still have more landlines than other regions, we guess it is because European countries have the habit of using landlines. Recently, the growth rate of mobile phones varies from country to country. Some countries are increasing rapidly, but some countries have seen negative growth. We guess recently in some countries the trend has already turn to switch from regular mobile phones to smartphones. At the same time, Monaco’s significantly higher rate of fixed-line phone ownership and Hong Kong’s average rate of two mobile phones per person also caught our attention.
In addition, through the analysis of if there is a relationship between per capita GDP and mobile phone ownership rate in each country, we found that the higher the per capita GDP is, the higher the growth rate of mobile phone subscription is. We also look into the trend in different regions and guess the possible reason.
Data communication is indispensable in our daily life, so it is interesting and worthwhile to analyze and explore this data. But we still believe that if combining the current data with smartphone subscription rate, age or education level we can get more interesting findings.
Figure 6.1: Average Landline and Mobile subscription from 1990-2017 for 100 people
| continent | average_gdp |
|---|---|
| Africa | 4,501 |
| Americas | 14,619 |
| Asia | 20,670 |
| Europe | 28,321 |
| Oceania | 9,200 |
{r, width = 10} # grid.arrange(b, c) #The following packages are used to produce this report: naniar (Tierney et al. 2020), dplyr (Wickham et al. 2021), readr(Wickham and Hester 2020), tidyverse (Wickham 2021), rgdal (Bivand, Keitt, and Rowlingson 2021), knitr (Xie 2021b), leaflet (Cheng, Karambelkar, and Xie 2021), ColorBrewer (Neuwirth 2014), ggplot2 (Wickham 2016), gganimate (Pedersen and Robinson 2020), gifski (Ooms 2021), plotly (Sievert 2020), bookdown(Xie 2021a), kableExtra (Zhu 2021), ggResidpane (Goode and Rey 2019), broom (Robinson, Hayes, and Couch 2021), janitor (Firke 2021), gridExtra (Auguie 2017).
The background map information came from Bjorn Sandvik (2021).